﻿using System;
using System.Collections.Generic;
using System.Data;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class control_tour_RightTourDuLich : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
        {
            
        }
    }
    protected string GetListDiaDanhNuocNgoai()
    {
        string htmlCode = "";
        string check = "?menu=174&parent=173";
        DataTable dt = DataAccess.ExeSQLToDataTable("select * from DiaDanh where CheckTour = '" + check + "'");
        foreach (DataRow row in dt.Rows)
        {
            htmlCode += @"<li>
                        <img src='style/css/img/icon_arrow2.gif' /><a href='tourdulich.aspx" + row["CheckTour"] + @"&id=" + row["IdYahoo"] + @"'>" + row["Name"] + @"</a>
                    </li>";
        }
        return htmlCode;
    }
    protected string GetListDuLichTheoNgay()
    {
        string htmlCode = "";
        string check = "?menu=162&parent=0";
        DataTable dt = DataAccess.ExeSQLToDataTable("select * from Ngay");
        foreach (DataRow row in dt.Rows)
        {
            htmlCode += @"<li>
                        <img src='style/css/img/icon_arrow3.png' /><a href='tourdulich.aspx?id=-2&idngay=" + row[0] + @"'>" + row["Name"] + @"</a>
                    </li>";
        }
        return htmlCode;
    }
}